{
 "cells": [
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "# Data Tables"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "This section covers so-called **data tables**. They provide an overview for certain topics in tabular form."
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 1,
   "metadata": {
    "collapsed": true
   },
   "outputs": [],
   "source": [
    "import fxcmpy\n",
    "import pandas as pd\n",
    "import datetime as dt\n",
    "con = fxcmpy.fxcmpy(config_file='fxcm.cfg')"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "## Account Information"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "The `con.get_accounts()` method shows **meta information** for the default or multiple accounts."
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 8,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style>\n",
       "    .dataframe thead tr:only-child th {\n",
       "        text-align: right;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: left;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>0</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>accountId</th>\n",
       "      <td>2815291</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>accountName</th>\n",
       "      <td>02815291</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>balance</th>\n",
       "      <td>505583</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>dayPL</th>\n",
       "      <td>-419.488</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>equity</th>\n",
       "      <td>505539</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>grossPL</th>\n",
       "      <td>-43.3377</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>hedging</th>\n",
       "      <td>N</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>mc</th>\n",
       "      <td>N</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>mcDate</th>\n",
       "      <td></td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>ratePrecision</th>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>t</th>\n",
       "      <td>6</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>usableMargin</th>\n",
       "      <td>503139</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>usableMargin3</th>\n",
       "      <td>503139</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>usableMargin3Perc</th>\n",
       "      <td>99.5253</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>usableMarginPerc</th>\n",
       "      <td>99.5253</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>usdMr</th>\n",
       "      <td>2400</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>usdMr3</th>\n",
       "      <td>2400</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "                          0\n",
       "accountId           2815291\n",
       "accountName        02815291\n",
       "balance              505583\n",
       "dayPL              -419.488\n",
       "equity               505539\n",
       "grossPL            -43.3377\n",
       "hedging                   N\n",
       "mc                        N\n",
       "mcDate                     \n",
       "ratePrecision             0\n",
       "t                         6\n",
       "usableMargin         503139\n",
       "usableMargin3        503139\n",
       "usableMargin3Perc   99.5253\n",
       "usableMarginPerc    99.5253\n",
       "usdMr                  2400\n",
       "usdMr3                 2400"
      ]
     },
     "execution_count": 8,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "con.get_accounts().T"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "## Offers"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "The `fxcm` connection object provides a number of methods to fetch **current data** from the API.\n",
    "\n",
    "The `con.get_offers()` method retrieves and displays a table with current **offers**."
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 2,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style>\n",
       "    .dataframe thead tr:only-child th {\n",
       "        text-align: right;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: left;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>buy</th>\n",
       "      <th>buyTradable</th>\n",
       "      <th>currency</th>\n",
       "      <th>defaultSortOrder</th>\n",
       "      <th>emr</th>\n",
       "      <th>fractionDigits</th>\n",
       "      <th>high</th>\n",
       "      <th>instrumentType</th>\n",
       "      <th>lmr</th>\n",
       "      <th>low</th>\n",
       "      <th>...</th>\n",
       "      <th>ratePrecision</th>\n",
       "      <th>rollB</th>\n",
       "      <th>rollS</th>\n",
       "      <th>sell</th>\n",
       "      <th>sellTradable</th>\n",
       "      <th>spread</th>\n",
       "      <th>t</th>\n",
       "      <th>time</th>\n",
       "      <th>valueDate</th>\n",
       "      <th>volume</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>1.19263</td>\n",
       "      <td>True</td>\n",
       "      <td>EUR/USD</td>\n",
       "      <td>100</td>\n",
       "      <td>0</td>\n",
       "      <td>5</td>\n",
       "      <td>1.19769</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>1.19144</td>\n",
       "      <td>...</td>\n",
       "      <td>5</td>\n",
       "      <td>-0.891</td>\n",
       "      <td>0.430</td>\n",
       "      <td>1.19240</td>\n",
       "      <td>True</td>\n",
       "      <td>2.3</td>\n",
       "      <td>0</td>\n",
       "      <td>+049994-10-22T06:53:50.000Z</td>\n",
       "      <td>01112018</td>\n",
       "      <td>1.00000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>112.51100</td>\n",
       "      <td>True</td>\n",
       "      <td>USD/JPY</td>\n",
       "      <td>200</td>\n",
       "      <td>0</td>\n",
       "      <td>3</td>\n",
       "      <td>113.19300</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>112.35600</td>\n",
       "      <td>...</td>\n",
       "      <td>3</td>\n",
       "      <td>0.305</td>\n",
       "      <td>-0.667</td>\n",
       "      <td>112.48900</td>\n",
       "      <td>True</td>\n",
       "      <td>2.2</td>\n",
       "      <td>0</td>\n",
       "      <td>+049994-10-22T07:34:09.000Z</td>\n",
       "      <td>01112018</td>\n",
       "      <td>1.00000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>1.35188</td>\n",
       "      <td>True</td>\n",
       "      <td>GBP/USD</td>\n",
       "      <td>300</td>\n",
       "      <td>0</td>\n",
       "      <td>5</td>\n",
       "      <td>1.35837</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>1.35044</td>\n",
       "      <td>...</td>\n",
       "      <td>5</td>\n",
       "      <td>-0.587</td>\n",
       "      <td>0.272</td>\n",
       "      <td>1.35166</td>\n",
       "      <td>True</td>\n",
       "      <td>2.2</td>\n",
       "      <td>0</td>\n",
       "      <td>+049994-10-22T07:38:53.000Z</td>\n",
       "      <td>01112018</td>\n",
       "      <td>1.00000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>0.98288</td>\n",
       "      <td>True</td>\n",
       "      <td>USD/CHF</td>\n",
       "      <td>400</td>\n",
       "      <td>0</td>\n",
       "      <td>5</td>\n",
       "      <td>0.98432</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0.97636</td>\n",
       "      <td>...</td>\n",
       "      <td>5</td>\n",
       "      <td>0.425</td>\n",
       "      <td>-1.016</td>\n",
       "      <td>0.98264</td>\n",
       "      <td>True</td>\n",
       "      <td>2.4</td>\n",
       "      <td>0</td>\n",
       "      <td>+049994-10-22T08:00:31.000Z</td>\n",
       "      <td>01112018</td>\n",
       "      <td>1.00000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>1.17206</td>\n",
       "      <td>True</td>\n",
       "      <td>EUR/CHF</td>\n",
       "      <td>500</td>\n",
       "      <td>0</td>\n",
       "      <td>5</td>\n",
       "      <td>1.17376</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>1.16831</td>\n",
       "      <td>...</td>\n",
       "      <td>5</td>\n",
       "      <td>0.038</td>\n",
       "      <td>-0.172</td>\n",
       "      <td>1.17182</td>\n",
       "      <td>True</td>\n",
       "      <td>2.4</td>\n",
       "      <td>0</td>\n",
       "      <td>+049994-10-22T08:00:28.000Z</td>\n",
       "      <td>01112018</td>\n",
       "      <td>1.01755</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5</th>\n",
       "      <td>0.78255</td>\n",
       "      <td>True</td>\n",
       "      <td>AUD/USD</td>\n",
       "      <td>600</td>\n",
       "      <td>0</td>\n",
       "      <td>5</td>\n",
       "      <td>0.78658</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0.78064</td>\n",
       "      <td>...</td>\n",
       "      <td>5</td>\n",
       "      <td>0.068</td>\n",
       "      <td>-0.166</td>\n",
       "      <td>0.78232</td>\n",
       "      <td>True</td>\n",
       "      <td>2.3</td>\n",
       "      <td>0</td>\n",
       "      <td>+049994-10-22T07:13:54.000Z</td>\n",
       "      <td>01112018</td>\n",
       "      <td>1.00000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6</th>\n",
       "      <td>1.24594</td>\n",
       "      <td>True</td>\n",
       "      <td>USD/CAD</td>\n",
       "      <td>700</td>\n",
       "      <td>0</td>\n",
       "      <td>5</td>\n",
       "      <td>1.24793</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>1.23970</td>\n",
       "      <td>...</td>\n",
       "      <td>5</td>\n",
       "      <td>0.092</td>\n",
       "      <td>-0.339</td>\n",
       "      <td>1.24570</td>\n",
       "      <td>True</td>\n",
       "      <td>2.4</td>\n",
       "      <td>0</td>\n",
       "      <td>+049994-10-22T07:32:52.000Z</td>\n",
       "      <td>01112018</td>\n",
       "      <td>1.00000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7</th>\n",
       "      <td>0.71840</td>\n",
       "      <td>True</td>\n",
       "      <td>NZD/USD</td>\n",
       "      <td>800</td>\n",
       "      <td>0</td>\n",
       "      <td>5</td>\n",
       "      <td>0.71985</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0.71615</td>\n",
       "      <td>...</td>\n",
       "      <td>5</td>\n",
       "      <td>0.066</td>\n",
       "      <td>-0.194</td>\n",
       "      <td>0.71816</td>\n",
       "      <td>True</td>\n",
       "      <td>2.4</td>\n",
       "      <td>0</td>\n",
       "      <td>+049994-10-22T06:46:27.000Z</td>\n",
       "      <td>01112018</td>\n",
       "      <td>1.00000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8</th>\n",
       "      <td>0.88230</td>\n",
       "      <td>True</td>\n",
       "      <td>EUR/GBP</td>\n",
       "      <td>900</td>\n",
       "      <td>0</td>\n",
       "      <td>5</td>\n",
       "      <td>0.88353</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0.88078</td>\n",
       "      <td>...</td>\n",
       "      <td>5</td>\n",
       "      <td>-0.447</td>\n",
       "      <td>0.183</td>\n",
       "      <td>0.88206</td>\n",
       "      <td>True</td>\n",
       "      <td>2.4</td>\n",
       "      <td>0</td>\n",
       "      <td>+049994-10-22T06:45:46.000Z</td>\n",
       "      <td>01112018</td>\n",
       "      <td>1.35157</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9</th>\n",
       "      <td>134.16900</td>\n",
       "      <td>True</td>\n",
       "      <td>EUR/JPY</td>\n",
       "      <td>1000</td>\n",
       "      <td>0</td>\n",
       "      <td>3</td>\n",
       "      <td>135.49100</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>134.04100</td>\n",
       "      <td>...</td>\n",
       "      <td>3</td>\n",
       "      <td>-0.143</td>\n",
       "      <td>0.042</td>\n",
       "      <td>134.14400</td>\n",
       "      <td>True</td>\n",
       "      <td>2.5</td>\n",
       "      <td>0</td>\n",
       "      <td>+049994-10-22T07:32:42.000Z</td>\n",
       "      <td>01112018</td>\n",
       "      <td>0.00889</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>10</th>\n",
       "      <td>152.09200</td>\n",
       "      <td>True</td>\n",
       "      <td>GBP/JPY</td>\n",
       "      <td>1100</td>\n",
       "      <td>0</td>\n",
       "      <td>3</td>\n",
       "      <td>153.59800</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>151.92400</td>\n",
       "      <td>...</td>\n",
       "      <td>3</td>\n",
       "      <td>0.144</td>\n",
       "      <td>-0.333</td>\n",
       "      <td>152.05600</td>\n",
       "      <td>True</td>\n",
       "      <td>3.6</td>\n",
       "      <td>0</td>\n",
       "      <td>+049994-10-22T07:32:53.000Z</td>\n",
       "      <td>01112018</td>\n",
       "      <td>0.00889</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>11</th>\n",
       "      <td>88.03700</td>\n",
       "      <td>True</td>\n",
       "      <td>AUD/JPY</td>\n",
       "      <td>1700</td>\n",
       "      <td>0</td>\n",
       "      <td>3</td>\n",
       "      <td>88.86100</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>87.85300</td>\n",
       "      <td>...</td>\n",
       "      <td>3</td>\n",
       "      <td>0.312</td>\n",
       "      <td>-0.680</td>\n",
       "      <td>88.01100</td>\n",
       "      <td>True</td>\n",
       "      <td>2.6</td>\n",
       "      <td>0</td>\n",
       "      <td>+049994-10-22T07:30:39.000Z</td>\n",
       "      <td>01112018</td>\n",
       "      <td>0.00889</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>12</th>\n",
       "      <td>1.72783</td>\n",
       "      <td>True</td>\n",
       "      <td>GBP/AUD</td>\n",
       "      <td>2200</td>\n",
       "      <td>0</td>\n",
       "      <td>5</td>\n",
       "      <td>1.73178</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>1.72400</td>\n",
       "      <td>...</td>\n",
       "      <td>5</td>\n",
       "      <td>-0.826</td>\n",
       "      <td>0.367</td>\n",
       "      <td>1.72749</td>\n",
       "      <td>True</td>\n",
       "      <td>3.4</td>\n",
       "      <td>0</td>\n",
       "      <td>+049994-10-22T07:40:07.000Z</td>\n",
       "      <td>01112018</td>\n",
       "      <td>0.78244</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>13</th>\n",
       "      <td>6.53290</td>\n",
       "      <td>True</td>\n",
       "      <td>USD/CNH</td>\n",
       "      <td>799</td>\n",
       "      <td>0</td>\n",
       "      <td>5</td>\n",
       "      <td>6.53914</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>6.49548</td>\n",
       "      <td>...</td>\n",
       "      <td>5</td>\n",
       "      <td>-0.702</td>\n",
       "      <td>0.192</td>\n",
       "      <td>6.53201</td>\n",
       "      <td>True</td>\n",
       "      <td>8.9</td>\n",
       "      <td>0</td>\n",
       "      <td>+049994-10-22T07:42:35.000Z</td>\n",
       "      <td></td>\n",
       "      <td>1.00000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>14</th>\n",
       "      <td>5517.80000</td>\n",
       "      <td>True</td>\n",
       "      <td>FRA40</td>\n",
       "      <td>100300</td>\n",
       "      <td>0</td>\n",
       "      <td>2</td>\n",
       "      <td>5525.50000</td>\n",
       "      <td>2</td>\n",
       "      <td>0</td>\n",
       "      <td>5480.50000</td>\n",
       "      <td>...</td>\n",
       "      <td>2</td>\n",
       "      <td>-0.050</td>\n",
       "      <td>-0.040</td>\n",
       "      <td>5516.80000</td>\n",
       "      <td>True</td>\n",
       "      <td>1.0</td>\n",
       "      <td>0</td>\n",
       "      <td>+049994-10-22T07:42:19.000Z</td>\n",
       "      <td>01112018</td>\n",
       "      <td>1.19239</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>15</th>\n",
       "      <td>13377.24000</td>\n",
       "      <td>True</td>\n",
       "      <td>GER30</td>\n",
       "      <td>100400</td>\n",
       "      <td>0</td>\n",
       "      <td>2</td>\n",
       "      <td>13427.75000</td>\n",
       "      <td>2</td>\n",
       "      <td>0</td>\n",
       "      <td>13356.05000</td>\n",
       "      <td>...</td>\n",
       "      <td>2</td>\n",
       "      <td>-0.120</td>\n",
       "      <td>-0.100</td>\n",
       "      <td>13376.36000</td>\n",
       "      <td>True</td>\n",
       "      <td>0.9</td>\n",
       "      <td>0</td>\n",
       "      <td>+049994-10-22T07:33:26.000Z</td>\n",
       "      <td>01112018</td>\n",
       "      <td>1.19239</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>16</th>\n",
       "      <td>7718.00000</td>\n",
       "      <td>True</td>\n",
       "      <td>UK100</td>\n",
       "      <td>101200</td>\n",
       "      <td>0</td>\n",
       "      <td>2</td>\n",
       "      <td>7733.00000</td>\n",
       "      <td>2</td>\n",
       "      <td>0</td>\n",
       "      <td>7707.30000</td>\n",
       "      <td>...</td>\n",
       "      <td>2</td>\n",
       "      <td>-0.100</td>\n",
       "      <td>-0.040</td>\n",
       "      <td>7717.00000</td>\n",
       "      <td>True</td>\n",
       "      <td>1.0</td>\n",
       "      <td>0</td>\n",
       "      <td>+049994-10-22T07:54:46.000Z</td>\n",
       "      <td>01112018</td>\n",
       "      <td>1.35157</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>17</th>\n",
       "      <td>25390.50000</td>\n",
       "      <td>True</td>\n",
       "      <td>US30</td>\n",
       "      <td>101300</td>\n",
       "      <td>0</td>\n",
       "      <td>2</td>\n",
       "      <td>25398.10000</td>\n",
       "      <td>2</td>\n",
       "      <td>0</td>\n",
       "      <td>25262.50000</td>\n",
       "      <td>...</td>\n",
       "      <td>2</td>\n",
       "      <td>-0.330</td>\n",
       "      <td>-0.020</td>\n",
       "      <td>25388.50000</td>\n",
       "      <td>True</td>\n",
       "      <td>2.0</td>\n",
       "      <td>0</td>\n",
       "      <td>+049994-10-22T07:49:06.000Z</td>\n",
       "      <td>01112018</td>\n",
       "      <td>1.00000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>18</th>\n",
       "      <td>11886.00000</td>\n",
       "      <td>True</td>\n",
       "      <td>USDOLLAR</td>\n",
       "      <td>105800</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>11897.00000</td>\n",
       "      <td>7</td>\n",
       "      <td>0</td>\n",
       "      <td>11856.00000</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>0.140</td>\n",
       "      <td>-0.360</td>\n",
       "      <td>11884.00000</td>\n",
       "      <td>True</td>\n",
       "      <td>2.0</td>\n",
       "      <td>0</td>\n",
       "      <td>+049994-10-22T06:44:10.000Z</td>\n",
       "      <td></td>\n",
       "      <td>1.00000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>19</th>\n",
       "      <td>1311.99000</td>\n",
       "      <td>True</td>\n",
       "      <td>XAU/USD</td>\n",
       "      <td>400100</td>\n",
       "      <td>0</td>\n",
       "      <td>2</td>\n",
       "      <td>1321.58000</td>\n",
       "      <td>5</td>\n",
       "      <td>0</td>\n",
       "      <td>1308.76000</td>\n",
       "      <td>...</td>\n",
       "      <td>2</td>\n",
       "      <td>-0.010</td>\n",
       "      <td>0.000</td>\n",
       "      <td>1311.60000</td>\n",
       "      <td>True</td>\n",
       "      <td>39.0</td>\n",
       "      <td>0</td>\n",
       "      <td>+049994-10-22T07:56:10.000Z</td>\n",
       "      <td>01112018</td>\n",
       "      <td>1.00000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>20</th>\n",
       "      <td>17.00200</td>\n",
       "      <td>True</td>\n",
       "      <td>XAG/USD</td>\n",
       "      <td>400200</td>\n",
       "      <td>0</td>\n",
       "      <td>3</td>\n",
       "      <td>17.18000</td>\n",
       "      <td>5</td>\n",
       "      <td>0</td>\n",
       "      <td>16.89400</td>\n",
       "      <td>...</td>\n",
       "      <td>3</td>\n",
       "      <td>-0.010</td>\n",
       "      <td>-0.002</td>\n",
       "      <td>16.95900</td>\n",
       "      <td>True</td>\n",
       "      <td>4.3</td>\n",
       "      <td>0</td>\n",
       "      <td>+049994-10-22T07:55:12.000Z</td>\n",
       "      <td>01112018</td>\n",
       "      <td>1.00000</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>21 rows × 25 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "            buy  buyTradable  currency  defaultSortOrder  emr  fractionDigits  \\\n",
       "0       1.19263         True   EUR/USD               100    0               5   \n",
       "1     112.51100         True   USD/JPY               200    0               3   \n",
       "2       1.35188         True   GBP/USD               300    0               5   \n",
       "3       0.98288         True   USD/CHF               400    0               5   \n",
       "4       1.17206         True   EUR/CHF               500    0               5   \n",
       "5       0.78255         True   AUD/USD               600    0               5   \n",
       "6       1.24594         True   USD/CAD               700    0               5   \n",
       "7       0.71840         True   NZD/USD               800    0               5   \n",
       "8       0.88230         True   EUR/GBP               900    0               5   \n",
       "9     134.16900         True   EUR/JPY              1000    0               3   \n",
       "10    152.09200         True   GBP/JPY              1100    0               3   \n",
       "11     88.03700         True   AUD/JPY              1700    0               3   \n",
       "12      1.72783         True   GBP/AUD              2200    0               5   \n",
       "13      6.53290         True   USD/CNH               799    0               5   \n",
       "14   5517.80000         True     FRA40            100300    0               2   \n",
       "15  13377.24000         True     GER30            100400    0               2   \n",
       "16   7718.00000         True     UK100            101200    0               2   \n",
       "17  25390.50000         True      US30            101300    0               2   \n",
       "18  11886.00000         True  USDOLLAR            105800    0               0   \n",
       "19   1311.99000         True   XAU/USD            400100    0               2   \n",
       "20     17.00200         True   XAG/USD            400200    0               3   \n",
       "\n",
       "           high  instrumentType  lmr          low   ...     ratePrecision  \\\n",
       "0       1.19769               1    0      1.19144   ...                 5   \n",
       "1     113.19300               1    0    112.35600   ...                 3   \n",
       "2       1.35837               1    0      1.35044   ...                 5   \n",
       "3       0.98432               1    0      0.97636   ...                 5   \n",
       "4       1.17376               1    0      1.16831   ...                 5   \n",
       "5       0.78658               1    0      0.78064   ...                 5   \n",
       "6       1.24793               1    0      1.23970   ...                 5   \n",
       "7       0.71985               1    0      0.71615   ...                 5   \n",
       "8       0.88353               1    0      0.88078   ...                 5   \n",
       "9     135.49100               1    0    134.04100   ...                 3   \n",
       "10    153.59800               1    0    151.92400   ...                 3   \n",
       "11     88.86100               1    0     87.85300   ...                 3   \n",
       "12      1.73178               1    0      1.72400   ...                 5   \n",
       "13      6.53914               1    0      6.49548   ...                 5   \n",
       "14   5525.50000               2    0   5480.50000   ...                 2   \n",
       "15  13427.75000               2    0  13356.05000   ...                 2   \n",
       "16   7733.00000               2    0   7707.30000   ...                 2   \n",
       "17  25398.10000               2    0  25262.50000   ...                 2   \n",
       "18  11897.00000               7    0  11856.00000   ...                 0   \n",
       "19   1321.58000               5    0   1308.76000   ...                 2   \n",
       "20     17.18000               5    0     16.89400   ...                 3   \n",
       "\n",
       "    rollB  rollS         sell  sellTradable  spread  t  \\\n",
       "0  -0.891  0.430      1.19240          True     2.3  0   \n",
       "1   0.305 -0.667    112.48900          True     2.2  0   \n",
       "2  -0.587  0.272      1.35166          True     2.2  0   \n",
       "3   0.425 -1.016      0.98264          True     2.4  0   \n",
       "4   0.038 -0.172      1.17182          True     2.4  0   \n",
       "5   0.068 -0.166      0.78232          True     2.3  0   \n",
       "6   0.092 -0.339      1.24570          True     2.4  0   \n",
       "7   0.066 -0.194      0.71816          True     2.4  0   \n",
       "8  -0.447  0.183      0.88206          True     2.4  0   \n",
       "9  -0.143  0.042    134.14400          True     2.5  0   \n",
       "10  0.144 -0.333    152.05600          True     3.6  0   \n",
       "11  0.312 -0.680     88.01100          True     2.6  0   \n",
       "12 -0.826  0.367      1.72749          True     3.4  0   \n",
       "13 -0.702  0.192      6.53201          True     8.9  0   \n",
       "14 -0.050 -0.040   5516.80000          True     1.0  0   \n",
       "15 -0.120 -0.100  13376.36000          True     0.9  0   \n",
       "16 -0.100 -0.040   7717.00000          True     1.0  0   \n",
       "17 -0.330 -0.020  25388.50000          True     2.0  0   \n",
       "18  0.140 -0.360  11884.00000          True     2.0  0   \n",
       "19 -0.010  0.000   1311.60000          True    39.0  0   \n",
       "20 -0.010 -0.002     16.95900          True     4.3  0   \n",
       "\n",
       "                           time  valueDate   volume  \n",
       "0   +049994-10-22T06:53:50.000Z   01112018  1.00000  \n",
       "1   +049994-10-22T07:34:09.000Z   01112018  1.00000  \n",
       "2   +049994-10-22T07:38:53.000Z   01112018  1.00000  \n",
       "3   +049994-10-22T08:00:31.000Z   01112018  1.00000  \n",
       "4   +049994-10-22T08:00:28.000Z   01112018  1.01755  \n",
       "5   +049994-10-22T07:13:54.000Z   01112018  1.00000  \n",
       "6   +049994-10-22T07:32:52.000Z   01112018  1.00000  \n",
       "7   +049994-10-22T06:46:27.000Z   01112018  1.00000  \n",
       "8   +049994-10-22T06:45:46.000Z   01112018  1.35157  \n",
       "9   +049994-10-22T07:32:42.000Z   01112018  0.00889  \n",
       "10  +049994-10-22T07:32:53.000Z   01112018  0.00889  \n",
       "11  +049994-10-22T07:30:39.000Z   01112018  0.00889  \n",
       "12  +049994-10-22T07:40:07.000Z   01112018  0.78244  \n",
       "13  +049994-10-22T07:42:35.000Z             1.00000  \n",
       "14  +049994-10-22T07:42:19.000Z   01112018  1.19239  \n",
       "15  +049994-10-22T07:33:26.000Z   01112018  1.19239  \n",
       "16  +049994-10-22T07:54:46.000Z   01112018  1.35157  \n",
       "17  +049994-10-22T07:49:06.000Z   01112018  1.00000  \n",
       "18  +049994-10-22T06:44:10.000Z             1.00000  \n",
       "19  +049994-10-22T07:56:10.000Z   01112018  1.00000  \n",
       "20  +049994-10-22T07:55:12.000Z   01112018  1.00000  \n",
       "\n",
       "[21 rows x 25 columns]"
      ]
     },
     "execution_count": 2,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "con.get_offers(kind='dataframe')"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "## Open Positions"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "The `con.get_open_positions()` method retrieves and shows the **open positions** for the default account."
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 3,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "[{'accountId': '2815291',\n",
       "  'accountName': '02815291',\n",
       "  'amountK': 100,\n",
       "  'close': 1.19273,\n",
       "  'com': 0,\n",
       "  'currency': 'EUR/USD',\n",
       "  'currencyPoint': 10,\n",
       "  'grossPL': -43,\n",
       "  'isBuy': False,\n",
       "  'isDisabled': False,\n",
       "  'limit': 0,\n",
       "  'open': 1.1923,\n",
       "  'ratePrecision': 5,\n",
       "  'roll': 0,\n",
       "  'stop': 0,\n",
       "  'stopMove': 0,\n",
       "  't': 1,\n",
       "  'time': '01092018164717',\n",
       "  'tradeId': '95985733',\n",
       "  'usedMargin': 1400,\n",
       "  'valueDate': '',\n",
       "  'visiblePL': -4.3},\n",
       " {'accountId': '2815291',\n",
       "  'accountName': '02815291',\n",
       "  'amountK': 100,\n",
       "  'close': 112.49,\n",
       "  'com': 0,\n",
       "  'currency': 'USD/JPY',\n",
       "  'currencyPoint': 8.88881,\n",
       "  'grossPL': -9.77865,\n",
       "  'isBuy': True,\n",
       "  'isDisabled': False,\n",
       "  'limit': 0,\n",
       "  'open': 112.501,\n",
       "  'ratePrecision': 3,\n",
       "  'roll': 0,\n",
       "  'stop': 0,\n",
       "  'stopMove': 0,\n",
       "  't': 1,\n",
       "  'time': '01092018164750',\n",
       "  'tradeId': '95985755',\n",
       "  'usedMargin': 1000,\n",
       "  'valueDate': '',\n",
       "  'visiblePL': -1.1}]"
      ]
     },
     "execution_count": 3,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "con.get_open_positions(kind='list')"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "## Closed Positions"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "Similarly, the `con.get_closed_positions()` method retrieves and presents the **closed positions**."
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "The parameter `kind` has to be `dataframe` (default) or `list`."
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 6,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style>\n",
       "    .dataframe thead tr:only-child th {\n",
       "        text-align: right;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: left;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>0</th>\n",
       "      <th>1</th>\n",
       "      <th>2</th>\n",
       "      <th>3</th>\n",
       "      <th>4</th>\n",
       "      <th>5</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>accountName</th>\n",
       "      <td>02815291</td>\n",
       "      <td>02815291</td>\n",
       "      <td>02815291</td>\n",
       "      <td>02815291</td>\n",
       "      <td>02815291</td>\n",
       "      <td>02815291</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>amountK</th>\n",
       "      <td>77</td>\n",
       "      <td>23</td>\n",
       "      <td>123</td>\n",
       "      <td>1000</td>\n",
       "      <td>500</td>\n",
       "      <td>123</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>close</th>\n",
       "      <td>1.19239</td>\n",
       "      <td>1.19239</td>\n",
       "      <td>1.19242</td>\n",
       "      <td>112.942</td>\n",
       "      <td>112.942</td>\n",
       "      <td>1.19372</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>closeTime</th>\n",
       "      <td>01092018164700</td>\n",
       "      <td>01092018164700</td>\n",
       "      <td>01092018164508</td>\n",
       "      <td>01092018090726</td>\n",
       "      <td>01092018090726</td>\n",
       "      <td>01092018090725</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>com</th>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>currency</th>\n",
       "      <td>EUR/USD</td>\n",
       "      <td>EUR/USD</td>\n",
       "      <td>EUR/USD</td>\n",
       "      <td>USD/JPY</td>\n",
       "      <td>USD/JPY</td>\n",
       "      <td>EUR/USD</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>currencyPoint</th>\n",
       "      <td>7.7</td>\n",
       "      <td>2.3</td>\n",
       "      <td>12.3</td>\n",
       "      <td>88.8905</td>\n",
       "      <td>44.4452</td>\n",
       "      <td>12.3</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>grossPL</th>\n",
       "      <td>-16.94</td>\n",
       "      <td>-5.52</td>\n",
       "      <td>-30.75</td>\n",
       "      <td>-194.79</td>\n",
       "      <td>-97.4</td>\n",
       "      <td>-30.75</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>isBuy</th>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>True</td>\n",
       "      <td>True</td>\n",
       "      <td>False</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>open</th>\n",
       "      <td>1.19217</td>\n",
       "      <td>1.19215</td>\n",
       "      <td>1.19217</td>\n",
       "      <td>112.964</td>\n",
       "      <td>112.964</td>\n",
       "      <td>1.19347</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>openTime</th>\n",
       "      <td>01092018164500</td>\n",
       "      <td>01092018164619</td>\n",
       "      <td>01092018164500</td>\n",
       "      <td>01092018090722</td>\n",
       "      <td>01092018090722</td>\n",
       "      <td>01092018090721</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>ratePrecision</th>\n",
       "      <td>5</td>\n",
       "      <td>5</td>\n",
       "      <td>5</td>\n",
       "      <td>3</td>\n",
       "      <td>3</td>\n",
       "      <td>5</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>roll</th>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>t</th>\n",
       "      <td>2</td>\n",
       "      <td>2</td>\n",
       "      <td>2</td>\n",
       "      <td>2</td>\n",
       "      <td>2</td>\n",
       "      <td>2</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>tradeId</th>\n",
       "      <td>143915603</td>\n",
       "      <td>95985636</td>\n",
       "      <td>95985496</td>\n",
       "      <td>95905933</td>\n",
       "      <td>95905927</td>\n",
       "      <td>95905921</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>valueDate</th>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>visiblePL</th>\n",
       "      <td>-2.2</td>\n",
       "      <td>-2.4</td>\n",
       "      <td>-2.5</td>\n",
       "      <td>-2.2</td>\n",
       "      <td>-2.2</td>\n",
       "      <td>-2.5</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "                            0               1               2               3  \\\n",
       "accountName          02815291        02815291        02815291        02815291   \n",
       "amountK                    77              23             123            1000   \n",
       "close                 1.19239         1.19239         1.19242         112.942   \n",
       "closeTime      01092018164700  01092018164700  01092018164508  01092018090726   \n",
       "com                         0               0               0               0   \n",
       "currency              EUR/USD         EUR/USD         EUR/USD         USD/JPY   \n",
       "currencyPoint             7.7             2.3            12.3         88.8905   \n",
       "grossPL                -16.94           -5.52          -30.75         -194.79   \n",
       "isBuy                   False           False           False            True   \n",
       "open                  1.19217         1.19215         1.19217         112.964   \n",
       "openTime       01092018164500  01092018164619  01092018164500  01092018090722   \n",
       "ratePrecision               5               5               5               3   \n",
       "roll                        0               0               0               0   \n",
       "t                           2               2               2               2   \n",
       "tradeId             143915603        95985636        95985496        95905933   \n",
       "valueDate                                                                       \n",
       "visiblePL                -2.2            -2.4            -2.5            -2.2   \n",
       "\n",
       "                            4               5  \n",
       "accountName          02815291        02815291  \n",
       "amountK                   500             123  \n",
       "close                 112.942         1.19372  \n",
       "closeTime      01092018090726  01092018090725  \n",
       "com                         0               0  \n",
       "currency              USD/JPY         EUR/USD  \n",
       "currencyPoint         44.4452            12.3  \n",
       "grossPL                 -97.4          -30.75  \n",
       "isBuy                    True           False  \n",
       "open                  112.964         1.19347  \n",
       "openTime       01092018090722  01092018090721  \n",
       "ratePrecision               3               5  \n",
       "roll                        0               0  \n",
       "t                           2               2  \n",
       "tradeId              95905927        95905921  \n",
       "valueDate                                      \n",
       "visiblePL                -2.2            -2.5  "
      ]
     },
     "execution_count": 6,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "con.get_closed_positions(kind='dataframe').T"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "## Open Orders"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "**Open orders** are retrieved via `con.get_orders()`."
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 7,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style>\n",
       "    .dataframe thead tr:only-child th {\n",
       "        text-align: right;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: left;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>0</th>\n",
       "      <th>1</th>\n",
       "      <th>2</th>\n",
       "      <th>3</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>accountId</th>\n",
       "      <td>2815291</td>\n",
       "      <td>2815291</td>\n",
       "      <td>2815291</td>\n",
       "      <td>2815291</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>accountName</th>\n",
       "      <td>02815291</td>\n",
       "      <td>02815291</td>\n",
       "      <td>02815291</td>\n",
       "      <td>02815291</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>amountK</th>\n",
       "      <td>123</td>\n",
       "      <td>123</td>\n",
       "      <td>123</td>\n",
       "      <td>123</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>buy</th>\n",
       "      <td>110</td>\n",
       "      <td>110</td>\n",
       "      <td>110</td>\n",
       "      <td>110</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>currency</th>\n",
       "      <td>USD/JPY</td>\n",
       "      <td>USD/JPY</td>\n",
       "      <td>USD/JPY</td>\n",
       "      <td>USD/JPY</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>currencyPoint</th>\n",
       "      <td>10.9339</td>\n",
       "      <td>10.9339</td>\n",
       "      <td>10.9339</td>\n",
       "      <td>10.9339</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>expireDate</th>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>isBuy</th>\n",
       "      <td>True</td>\n",
       "      <td>True</td>\n",
       "      <td>True</td>\n",
       "      <td>True</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>isELSOrder</th>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>isEntryOrder</th>\n",
       "      <td>True</td>\n",
       "      <td>True</td>\n",
       "      <td>True</td>\n",
       "      <td>True</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>isLimitOrder</th>\n",
       "      <td>True</td>\n",
       "      <td>True</td>\n",
       "      <td>True</td>\n",
       "      <td>True</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>isNetQuantity</th>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>isStopOrder</th>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>limit</th>\n",
       "      <td>112</td>\n",
       "      <td>112</td>\n",
       "      <td>112</td>\n",
       "      <td>112</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>limitPegBaseType</th>\n",
       "      <td>-1</td>\n",
       "      <td>-1</td>\n",
       "      <td>-1</td>\n",
       "      <td>-1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>limitRate</th>\n",
       "      <td>112</td>\n",
       "      <td>112</td>\n",
       "      <td>112</td>\n",
       "      <td>112</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>ocoBulkId</th>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>orderId</th>\n",
       "      <td>94110644</td>\n",
       "      <td>95845790</td>\n",
       "      <td>95948022</td>\n",
       "      <td>95841449</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>range</th>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>ratePrecision</th>\n",
       "      <td>3</td>\n",
       "      <td>3</td>\n",
       "      <td>3</td>\n",
       "      <td>3</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>sell</th>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>status</th>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>stop</th>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>stopMove</th>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>stopPegBaseType</th>\n",
       "      <td>-1</td>\n",
       "      <td>-1</td>\n",
       "      <td>-1</td>\n",
       "      <td>-1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>stopRate</th>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>t</th>\n",
       "      <td>3</td>\n",
       "      <td>3</td>\n",
       "      <td>3</td>\n",
       "      <td>3</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>time</th>\n",
       "      <td>12132017082534</td>\n",
       "      <td>01082018154949</td>\n",
       "      <td>01092018134122</td>\n",
       "      <td>01082018151410</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>timeInForce</th>\n",
       "      <td>GTC</td>\n",
       "      <td>GTC</td>\n",
       "      <td>GTC</td>\n",
       "      <td>GTC</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>tradeId</th>\n",
       "      <td>94110645</td>\n",
       "      <td>95845791</td>\n",
       "      <td>95948023</td>\n",
       "      <td>95841450</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>type</th>\n",
       "      <td>LE</td>\n",
       "      <td>LE</td>\n",
       "      <td>LE</td>\n",
       "      <td>LE</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "                               0               1               2  \\\n",
       "accountId                2815291         2815291         2815291   \n",
       "accountName             02815291        02815291        02815291   \n",
       "amountK                      123             123             123   \n",
       "buy                          110             110             110   \n",
       "currency                 USD/JPY         USD/JPY         USD/JPY   \n",
       "currencyPoint            10.9339         10.9339         10.9339   \n",
       "expireDate                                                         \n",
       "isBuy                       True            True            True   \n",
       "isELSOrder                 False           False           False   \n",
       "isEntryOrder                True            True            True   \n",
       "isLimitOrder                True            True            True   \n",
       "isNetQuantity              False           False           False   \n",
       "isStopOrder                False           False           False   \n",
       "limit                        112             112             112   \n",
       "limitPegBaseType              -1              -1              -1   \n",
       "limitRate                    112             112             112   \n",
       "ocoBulkId                      0               0               0   \n",
       "orderId                 94110644        95845790        95948022   \n",
       "range                          0               0               0   \n",
       "ratePrecision                  3               3               3   \n",
       "sell                           0               0               0   \n",
       "status                         1               1               1   \n",
       "stop                           0               0               0   \n",
       "stopMove                       0               0               0   \n",
       "stopPegBaseType               -1              -1              -1   \n",
       "stopRate                       0               0               0   \n",
       "t                              3               3               3   \n",
       "time              12132017082534  01082018154949  01092018134122   \n",
       "timeInForce                  GTC             GTC             GTC   \n",
       "tradeId                 94110645        95845791        95948023   \n",
       "type                          LE              LE              LE   \n",
       "\n",
       "                               3  \n",
       "accountId                2815291  \n",
       "accountName             02815291  \n",
       "amountK                      123  \n",
       "buy                          110  \n",
       "currency                 USD/JPY  \n",
       "currencyPoint            10.9339  \n",
       "expireDate                        \n",
       "isBuy                       True  \n",
       "isELSOrder                 False  \n",
       "isEntryOrder                True  \n",
       "isLimitOrder                True  \n",
       "isNetQuantity              False  \n",
       "isStopOrder                False  \n",
       "limit                        112  \n",
       "limitPegBaseType              -1  \n",
       "limitRate                    112  \n",
       "ocoBulkId                      0  \n",
       "orderId                 95841449  \n",
       "range                          0  \n",
       "ratePrecision                  3  \n",
       "sell                           0  \n",
       "status                         1  \n",
       "stop                           0  \n",
       "stopMove                       0  \n",
       "stopPegBaseType               -1  \n",
       "stopRate                       0  \n",
       "t                              3  \n",
       "time              01082018151410  \n",
       "timeInForce                  GTC  \n",
       "tradeId                 95841450  \n",
       "type                          LE  "
      ]
     },
     "execution_count": 7,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "con.get_orders().T"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "## Summaries"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "A **summary** can be created over all open or closed positions, over an account or over \"everything\". "
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 9,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style>\n",
       "    .dataframe thead tr:only-child th {\n",
       "        text-align: right;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: left;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>0</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>accountId</th>\n",
       "      <td></td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>accountName</th>\n",
       "      <td></td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>amountK</th>\n",
       "      <td>200</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>close</th>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>com</th>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>currency</th>\n",
       "      <td></td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>currencyPoint</th>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>grossPL</th>\n",
       "      <td>-45.0055</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>isBuy</th>\n",
       "      <td>False</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>isDisabled</th>\n",
       "      <td>False</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>isTotal</th>\n",
       "      <td>True</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>limit</th>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>open</th>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>ratePrecision</th>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>roll</th>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>stop</th>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>stopMove</th>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>t</th>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>time</th>\n",
       "      <td>None</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>tradeId</th>\n",
       "      <td></td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>usedMargin</th>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>valueDate</th>\n",
       "      <td></td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>visiblePL</th>\n",
       "      <td>-4.8</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "                     0\n",
       "accountId             \n",
       "accountName           \n",
       "amountK            200\n",
       "close                0\n",
       "com                  0\n",
       "currency              \n",
       "currencyPoint        0\n",
       "grossPL       -45.0055\n",
       "isBuy            False\n",
       "isDisabled       False\n",
       "isTotal           True\n",
       "limit                0\n",
       "open                 0\n",
       "ratePrecision        0\n",
       "roll                 0\n",
       "stop                 0\n",
       "stopMove             0\n",
       "t                    1\n",
       "time              None\n",
       "tradeId               \n",
       "usedMargin           0\n",
       "valueDate             \n",
       "visiblePL         -4.8"
      ]
     },
     "execution_count": 9,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "con.get_open_positions_summary().T"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 10,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style>\n",
       "    .dataframe thead tr:only-child th {\n",
       "        text-align: right;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: left;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>0</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>accountName</th>\n",
       "      <td></td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>amountK</th>\n",
       "      <td>1846</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>close</th>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>closeTime</th>\n",
       "      <td>None</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>com</th>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>currency</th>\n",
       "      <td></td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>currencyPoint</th>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>grossPL</th>\n",
       "      <td>-376.15</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>isBuy</th>\n",
       "      <td>False</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>isTotal</th>\n",
       "      <td>True</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>open</th>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>openTime</th>\n",
       "      <td>None</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>ratePrecision</th>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>roll</th>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>t</th>\n",
       "      <td>2</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>tradeId</th>\n",
       "      <td></td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>valueDate</th>\n",
       "      <td></td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>visiblePL</th>\n",
       "      <td>-14</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "                    0\n",
       "accountName          \n",
       "amountK          1846\n",
       "close               0\n",
       "closeTime        None\n",
       "com                 0\n",
       "currency             \n",
       "currencyPoint       0\n",
       "grossPL       -376.15\n",
       "isBuy           False\n",
       "isTotal          True\n",
       "open                0\n",
       "openTime         None\n",
       "ratePrecision       0\n",
       "roll                0\n",
       "t                   2\n",
       "tradeId              \n",
       "valueDate            \n",
       "visiblePL         -14"
      ]
     },
     "execution_count": 10,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "con.get_closed_positions_summary().T"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 11,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style>\n",
       "    .dataframe thead tr:only-child th {\n",
       "        text-align: right;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: left;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>0</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>accountId</th>\n",
       "      <td></td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>accountName</th>\n",
       "      <td></td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>balance</th>\n",
       "      <td>505583</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>dayPL</th>\n",
       "      <td>-418.598</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>equity</th>\n",
       "      <td>505540</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>grossPL</th>\n",
       "      <td>-42.4484</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>hedging</th>\n",
       "      <td></td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>isTotal</th>\n",
       "      <td>True</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>mc</th>\n",
       "      <td></td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>mcDate</th>\n",
       "      <td>None</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>ratePrecision</th>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>t</th>\n",
       "      <td>6</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>usableMargin</th>\n",
       "      <td>503140</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>usableMargin3</th>\n",
       "      <td>503140</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>usableMargin3Perc</th>\n",
       "      <td>99.5253</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>usableMarginPerc</th>\n",
       "      <td>99.5253</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>usdMr</th>\n",
       "      <td>2400</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>usdMr3</th>\n",
       "      <td>2400</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "                         0\n",
       "accountId                 \n",
       "accountName               \n",
       "balance             505583\n",
       "dayPL             -418.598\n",
       "equity              505540\n",
       "grossPL           -42.4484\n",
       "hedging                   \n",
       "isTotal               True\n",
       "mc                        \n",
       "mcDate                None\n",
       "ratePrecision            0\n",
       "t                        6\n",
       "usableMargin        503140\n",
       "usableMargin3       503140\n",
       "usableMargin3Perc  99.5253\n",
       "usableMarginPerc   99.5253\n",
       "usdMr                 2400\n",
       "usdMr3                2400"
      ]
     },
     "execution_count": 11,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "con.get_accounts_summary().T"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 12,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style>\n",
       "    .dataframe thead tr:only-child th {\n",
       "        text-align: right;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: left;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>0</th>\n",
       "      <th>1</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>amountK</th>\n",
       "      <td>-100</td>\n",
       "      <td>100</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>amountKBuy</th>\n",
       "      <td>0</td>\n",
       "      <td>100</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>amountKSell</th>\n",
       "      <td>100</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>avgBuy</th>\n",
       "      <td>0</td>\n",
       "      <td>112.501</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>avgSell</th>\n",
       "      <td>1.1923</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>closeBuy</th>\n",
       "      <td>1.19256</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>closeSell</th>\n",
       "      <td>0</td>\n",
       "      <td>112.475</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>currency</th>\n",
       "      <td>EUR/USD</td>\n",
       "      <td>USD/JPY</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>currencyPoint</th>\n",
       "      <td>-10</td>\n",
       "      <td>8.89003</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>grossPL</th>\n",
       "      <td>-26</td>\n",
       "      <td>-23.1163</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>isBuyDisabled</th>\n",
       "      <td>True</td>\n",
       "      <td>False</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>isSellDisabled</th>\n",
       "      <td>False</td>\n",
       "      <td>True</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>netLimit</th>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>netPL</th>\n",
       "      <td>-26</td>\n",
       "      <td>-23.1163</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>netStop</th>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>netStopMove</th>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>offerId</th>\n",
       "      <td>1</td>\n",
       "      <td>2</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>plBuy</th>\n",
       "      <td>0</td>\n",
       "      <td>-23.1163</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>plSell</th>\n",
       "      <td>-26</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>ratePrecision</th>\n",
       "      <td>5</td>\n",
       "      <td>3</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>rollSum</th>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>t</th>\n",
       "      <td>5</td>\n",
       "      <td>5</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>usedMargin</th>\n",
       "      <td>1400</td>\n",
       "      <td>1000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>usedMarginBuy</th>\n",
       "      <td>0</td>\n",
       "      <td>1000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>usedMarginSell</th>\n",
       "      <td>1400</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "                      0        1\n",
       "amountK            -100      100\n",
       "amountKBuy            0      100\n",
       "amountKSell         100        0\n",
       "avgBuy                0  112.501\n",
       "avgSell          1.1923        0\n",
       "closeBuy        1.19256        0\n",
       "closeSell             0  112.475\n",
       "currency        EUR/USD  USD/JPY\n",
       "currencyPoint       -10  8.89003\n",
       "grossPL             -26 -23.1163\n",
       "isBuyDisabled      True    False\n",
       "isSellDisabled    False     True\n",
       "netLimit              0        0\n",
       "netPL               -26 -23.1163\n",
       "netStop               0        0\n",
       "netStopMove           0        0\n",
       "offerId               1        2\n",
       "plBuy                 0 -23.1163\n",
       "plSell              -26        0\n",
       "ratePrecision         5        3\n",
       "rollSum               0        0\n",
       "t                     5        5\n",
       "usedMargin         1400     1000\n",
       "usedMarginBuy         0     1000\n",
       "usedMarginSell     1400        0"
      ]
     },
     "execution_count": 12,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "con.get_summary().T"
   ]
  }
 ],
 "metadata": {
  "kernelspec": {
   "display_name": "Python 3",
   "language": "python",
   "name": "python3"
  },
  "language_info": {
   "codemirror_mode": {
    "name": "ipython",
    "version": 3
   },
   "file_extension": ".py",
   "mimetype": "text/x-python",
   "name": "python",
   "nbconvert_exporter": "python",
   "pygments_lexer": "ipython3",
   "version": "3.6.4"
  }
 },
 "nbformat": 4,
 "nbformat_minor": 2
}
